The following errors might occur when you export SAS^® Stored Processes that contain one or more shared prompts or when you individually export a shared prompt:

INFO  - ******** Exporting Metadata ********
ERROR - Failure exporting metadata from source server. 
Reason: The public type definition 'Prompt' (version 1), specified by object
Prompt : 'PROMPT_NAME' (ID="A59ONK7H.CB0000LU"), does not exist.
INFO  - The export process has finished with errors.

This problem is most likely to occur if you edit the shared prompt using SAS^® Management Console.

You can correct this problem by running the SAS program that appears on the Full Code tab in this note.

Click the Hot Fix tab in this note to access the hot fix for this issue.

For customers running the second maintenance release for SAS^® 9.3 (TS1M2), applying Hot Fix I15011 is necessary to avoid future problems with exporting shared prompts.

For customers running SAS^® 9.4 (TS1M0), applying Hot Fix L45002 is necessary to avoid future problems with exporting shared prompts.

After you apply the appropriate hot fix, new shared prompts will export correctly. However, you do need to correct existing shared prompts that you create and edite before the hot-fix application. As mentioned previously, you can correct these existing prompts using the program that is included on the Full Code tab in this note.

Operating System and Release Information

/*===================================================================*/
/* INPUT INPUT INPUT INPUT INPUT INPUT INPUT INPUT INPUT INPUT INPUT */
/*  You must specify the path to your Metadata Server directory      */
/*===================================================================*/

%let Metadata_Server_Dir =D:\sasconfig\Lev1\SASMeta\MetadataServer;

/*===================================================================*/
/* - END INPUT - END INPUT - END INPUT - END INPUT - ENDE INPUT -    */
/*===================================================================*/

/* Metadata-Server Parameter list------------------------------------*/
/* Metadata-Parameter-Options with metaparms.sas File                */
%include "&Metadata_Server_Dir\metaparms.sas";

/*-------------------------------------------------------------------*/
/* Read all corrupt prompts from Metadata                            */
/*-------------------------------------------------------------------*/
data Corrupt_Prompts;
   length pruri UV  $256;
   rc=1;
   n =1;
   do while(rc>0);
      rc=metadata_getnobj("omsobj:Prompt?@Id contains '.'",n,pruri);
      if rc > 0 then do;
	 rcn=metadata_getattr(pruri,"UsageVersion",UV);
      if UV = "1" then output;
      end;
      n=n+1;
      end;
run;

/*-------------------------------------------------------------------*/
/* Print all corrupt prompts                                         */
/*-------------------------------------------------------------------*/
Title "Prompts that need to be fixed";
proc print data=Corrupt_Prompts;
run;

/*-------------------------------------------------------------------*/
/* Update Metadata                                                   */
/*-------------------------------------------------------------------*/
data _null_;
   set Corrupt_Prompts;
   rcn=metadata_setattr(pruri,"UsageVersion","1000000");
run;
/*===================================================================*/

A fix for this issue for SAS Management Console 9.4 is available at:

A fix for this issue for SAS Middle Tier 9.4 is available at:

A fix for this issue for SAS Middle Tier 9.3_M2 is available at:

A fix for this issue for SAS Management Console 9.3_M2 is available at: